package com.yxw.live_vod_boot.service.impl;



import lombok.extern.slf4j.Slf4j;
//import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import java.util.List;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yxw.yxnet_cd_center.common.utils.BaseResult;
import com.yxw.yxnet_cd_center.common.utils.BaseDateTime;
import org.springframework.transaction.annotation.Transactional;
import cn.hutool.core.bean.BeanUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import cn.hutool.core.util.ObjectUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.yxw.live_vod_boot.entity.LiveShopApplyAddressEntity;
import com.yxw.live_vod_boot.dto.LiveShopApplyAddressDTO;
import com.yxw.live_vod_facade.dto.LiveShopApplyAddressAddDTO;
import com.yxw.live_vod_boot.dto.LiveShopApplyAddressQueryDTO;
import com.yxw.live_vod_boot.mapper.LiveShopApplyAddressMapper;
import com.yxw.live_vod_boot.service.ILiveShopApplyAddressService;



/*** 
*@author Jiaxu.Huang
*@date 2024/1/22 15:18:29
*@update 2024/1/22 15:18:29
**/
@Slf4j
@Service
//public class LiveShopApplyAddressServiceImpl  extends ServiceImpl<LiveShopApplyAddressMapper, LiveShopApplyAddressEntity> implements ILiveShopApplyAddressService{
public class LiveShopApplyAddressServiceImpl  implements ILiveShopApplyAddressService{
    @Autowired
    private LiveShopApplyAddressMapper oLiveShopApplyAddressMapper;
    /*** 
    * 根据直播id查找直播详情
    * @param id
    * @return LiveShopApplyAddressEntity
    **/
    @Override
    public LiveShopApplyAddressEntity selectLiveShopApplyAddressById(String liveId)
    {
        if(ObjectUtil.isEmpty(liveId))
        {
            return null;
        }
        return oLiveShopApplyAddressMapper.selectById(liveId);
    }
    /*** 
    * 自定义查询VIEW
    * @param oLiveShopApplyAddressDTO
    * @return List<LiveShopApplyAddressEntity>
    **/
    @Override
    public List<LiveShopApplyAddressEntity> selectLiveShopApplyAddressList(LiveShopApplyAddressQueryDTO oLiveShopApplyAddressQueryDTO)
    {
        QueryWrapper<LiveShopApplyAddressEntity> oLiveShopApplyAddressQueryWrapper = new QueryWrapper();
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getId()),"id",oLiveShopApplyAddressQueryDTO.getId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopName()),"shop_name",oLiveShopApplyAddressQueryDTO.getShopName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getMerchantName()),"merchant_name",oLiveShopApplyAddressQueryDTO.getMerchantName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveHomeName()),"live_home_name",oLiveShopApplyAddressQueryDTO.getLiveHomeName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveHomePicture()),"live_home_picture",oLiveShopApplyAddressQueryDTO.getLiveHomePicture());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveId()),"live_id",oLiveShopApplyAddressQueryDTO.getLiveId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveShopId()),"live_shop_id",oLiveShopApplyAddressQueryDTO.getLiveShopId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopId()),"shop_id",oLiveShopApplyAddressQueryDTO.getShopId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getApplyId()),"apply_id",oLiveShopApplyAddressQueryDTO.getApplyId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopUserId()),"shop_user_id",oLiveShopApplyAddressQueryDTO.getShopUserId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopUserName()),"shop_user_name",oLiveShopApplyAddressQueryDTO.getShopUserName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCreateUserId()),"create_user_id",oLiveShopApplyAddressQueryDTO.getCreateUserId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveAuthType()),"live_auth_type",oLiveShopApplyAddressQueryDTO.getLiveAuthType());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveStartTime()),"live_start_time",oLiveShopApplyAddressQueryDTO.getLiveStartTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveEndTime()),"live_end_time",oLiveShopApplyAddressQueryDTO.getLiveEndTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveAppName()),"live_app_name",oLiveShopApplyAddressQueryDTO.getLiveAppName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveStreamName()),"live_stream_name",oLiveShopApplyAddressQueryDTO.getLiveStreamName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushAuth()),"push_auth",oLiveShopApplyAddressQueryDTO.getPushAuth());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushUrl()),"push_url",oLiveShopApplyAddressQueryDTO.getPushUrl());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveUrl()),"live_url",oLiveShopApplyAddressQueryDTO.getLiveUrl());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLivePicture()),"live_picture",oLiveShopApplyAddressQueryDTO.getLivePicture());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveDescription()),"live_description",oLiveShopApplyAddressQueryDTO.getLiveDescription());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveTag()),"live_tag",oLiveShopApplyAddressQueryDTO.getLiveTag());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveState()),"live_state",oLiveShopApplyAddressQueryDTO.getLiveState());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveWillSave()),"live_will_save",oLiveShopApplyAddressQueryDTO.getLiveWillSave());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveFeesType()),"live_fees_type",oLiveShopApplyAddressQueryDTO.getLiveFeesType());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveUserPush()),"live_user_push",oLiveShopApplyAddressQueryDTO.getLiveUserPush());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushStartTime()),"push_start_time",oLiveShopApplyAddressQueryDTO.getPushStartTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushEndTime()),"push_end_time",oLiveShopApplyAddressQueryDTO.getPushEndTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushStartServerTime()),"push_start_server_time",oLiveShopApplyAddressQueryDTO.getPushStartServerTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushEndServerTime()),"push_end_server_time",oLiveShopApplyAddressQueryDTO.getPushEndServerTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveTotallDuration()),"live_totall_duration",oLiveShopApplyAddressQueryDTO.getLiveTotallDuration());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveTotallPushLength()),"live_totall_push_length",oLiveShopApplyAddressQueryDTO.getLiveTotallPushLength());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveFees()),"live_fees",oLiveShopApplyAddressQueryDTO.getLiveFees());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveValuation()),"live_valuation",oLiveShopApplyAddressQueryDTO.getLiveValuation());
        oLiveShopApplyAddressQueryWrapper.ge(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCreateTimeStart()),"create_time",oLiveShopApplyAddressQueryDTO.getCreateTimeStart());
        oLiveShopApplyAddressQueryWrapper.le(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCreateTimeEnd()),"create_time",oLiveShopApplyAddressQueryDTO.getCreateTimeEnd());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getUpdateTime()),"update_time",oLiveShopApplyAddressQueryDTO.getUpdateTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchNumber()),"watch_number",oLiveShopApplyAddressQueryDTO.getWatchNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchUserCount()),"watch_user_count",oLiveShopApplyAddressQueryDTO.getWatchUserCount());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchDuration()),"watch_duration",oLiveShopApplyAddressQueryDTO.getWatchDuration());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchStreamLength()),"watch_stream_length",oLiveShopApplyAddressQueryDTO.getWatchStreamLength());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getMaxOnlineUserCount()),"max_online_user_count",oLiveShopApplyAddressQueryDTO.getMaxOnlineUserCount());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getAveragWatchDuration()),"averag_watch_duration",oLiveShopApplyAddressQueryDTO.getAveragWatchDuration());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveOrderCount()),"live_order_count",oLiveShopApplyAddressQueryDTO.getLiveOrderCount());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveOrderTotalFee()),"live_order_total_fee",oLiveShopApplyAddressQueryDTO.getLiveOrderTotalFee());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchUserPayRate()),"watch_user_pay_rate",oLiveShopApplyAddressQueryDTO.getWatchUserPayRate());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getAddedFansNumber()),"added_fans_number",oLiveShopApplyAddressQueryDTO.getAddedFansNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCommentNumber()),"comment_number",oLiveShopApplyAddressQueryDTO.getCommentNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCommentUserNumber()),"comment_user_number",oLiveShopApplyAddressQueryDTO.getCommentUserNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLikeNumber()),"like_number",oLiveShopApplyAddressQueryDTO.getLikeNumber());
        //List<LiveShopApplyAddressEntity> oListLiveShopApplyAddress = oLiveShopApplyAddressMapper.selectList(oLiveShopApplyAddressQueryWrapper);
        //return Res.ok(oListLiveShopApplyAddress);
        return  oLiveShopApplyAddressMapper.selectList(oLiveShopApplyAddressQueryWrapper);
    }
    /*** 
    * 自定义统计VIEW
    * @param oLiveShopApplyAddressEntity
    * @return Integer
    **/
    @Override
    public Integer selectLiveShopApplyAddressCount(LiveShopApplyAddressQueryDTO oLiveShopApplyAddressQueryDTO)
    {
        QueryWrapper<LiveShopApplyAddressEntity> oLiveShopApplyAddressQueryWrapper = new QueryWrapper();
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getId()),"id",oLiveShopApplyAddressQueryDTO.getId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopName()),"shop_name",oLiveShopApplyAddressQueryDTO.getShopName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getMerchantName()),"merchant_name",oLiveShopApplyAddressQueryDTO.getMerchantName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveHomeName()),"live_home_name",oLiveShopApplyAddressQueryDTO.getLiveHomeName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveHomePicture()),"live_home_picture",oLiveShopApplyAddressQueryDTO.getLiveHomePicture());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveId()),"live_id",oLiveShopApplyAddressQueryDTO.getLiveId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveShopId()),"live_shop_id",oLiveShopApplyAddressQueryDTO.getLiveShopId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopId()),"shop_id",oLiveShopApplyAddressQueryDTO.getShopId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getApplyId()),"apply_id",oLiveShopApplyAddressQueryDTO.getApplyId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopUserId()),"shop_user_id",oLiveShopApplyAddressQueryDTO.getShopUserId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopUserName()),"shop_user_name",oLiveShopApplyAddressQueryDTO.getShopUserName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCreateUserId()),"create_user_id",oLiveShopApplyAddressQueryDTO.getCreateUserId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveAuthType()),"live_auth_type",oLiveShopApplyAddressQueryDTO.getLiveAuthType());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveStartTime()),"live_start_time",oLiveShopApplyAddressQueryDTO.getLiveStartTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveEndTime()),"live_end_time",oLiveShopApplyAddressQueryDTO.getLiveEndTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveAppName()),"live_app_name",oLiveShopApplyAddressQueryDTO.getLiveAppName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveStreamName()),"live_stream_name",oLiveShopApplyAddressQueryDTO.getLiveStreamName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushAuth()),"push_auth",oLiveShopApplyAddressQueryDTO.getPushAuth());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushUrl()),"push_url",oLiveShopApplyAddressQueryDTO.getPushUrl());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveUrl()),"live_url",oLiveShopApplyAddressQueryDTO.getLiveUrl());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLivePicture()),"live_picture",oLiveShopApplyAddressQueryDTO.getLivePicture());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveDescription()),"live_description",oLiveShopApplyAddressQueryDTO.getLiveDescription());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveTag()),"live_tag",oLiveShopApplyAddressQueryDTO.getLiveTag());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveState()),"live_state",oLiveShopApplyAddressQueryDTO.getLiveState());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveWillSave()),"live_will_save",oLiveShopApplyAddressQueryDTO.getLiveWillSave());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveFeesType()),"live_fees_type",oLiveShopApplyAddressQueryDTO.getLiveFeesType());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveUserPush()),"live_user_push",oLiveShopApplyAddressQueryDTO.getLiveUserPush());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushStartTime()),"push_start_time",oLiveShopApplyAddressQueryDTO.getPushStartTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushEndTime()),"push_end_time",oLiveShopApplyAddressQueryDTO.getPushEndTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushStartServerTime()),"push_start_server_time",oLiveShopApplyAddressQueryDTO.getPushStartServerTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushEndServerTime()),"push_end_server_time",oLiveShopApplyAddressQueryDTO.getPushEndServerTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveTotallDuration()),"live_totall_duration",oLiveShopApplyAddressQueryDTO.getLiveTotallDuration());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveTotallPushLength()),"live_totall_push_length",oLiveShopApplyAddressQueryDTO.getLiveTotallPushLength());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveFees()),"live_fees",oLiveShopApplyAddressQueryDTO.getLiveFees());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveValuation()),"live_valuation",oLiveShopApplyAddressQueryDTO.getLiveValuation());
        oLiveShopApplyAddressQueryWrapper.ge(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCreateTimeStart()),"create_time",oLiveShopApplyAddressQueryDTO.getCreateTimeStart());
        oLiveShopApplyAddressQueryWrapper.le(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCreateTimeEnd()),"create_time",oLiveShopApplyAddressQueryDTO.getCreateTimeEnd());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getUpdateTime()),"update_time",oLiveShopApplyAddressQueryDTO.getUpdateTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchNumber()),"watch_number",oLiveShopApplyAddressQueryDTO.getWatchNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchUserCount()),"watch_user_count",oLiveShopApplyAddressQueryDTO.getWatchUserCount());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchDuration()),"watch_duration",oLiveShopApplyAddressQueryDTO.getWatchDuration());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchStreamLength()),"watch_stream_length",oLiveShopApplyAddressQueryDTO.getWatchStreamLength());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getMaxOnlineUserCount()),"max_online_user_count",oLiveShopApplyAddressQueryDTO.getMaxOnlineUserCount());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getAveragWatchDuration()),"averag_watch_duration",oLiveShopApplyAddressQueryDTO.getAveragWatchDuration());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveOrderCount()),"live_order_count",oLiveShopApplyAddressQueryDTO.getLiveOrderCount());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveOrderTotalFee()),"live_order_total_fee",oLiveShopApplyAddressQueryDTO.getLiveOrderTotalFee());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchUserPayRate()),"watch_user_pay_rate",oLiveShopApplyAddressQueryDTO.getWatchUserPayRate());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getAddedFansNumber()),"added_fans_number",oLiveShopApplyAddressQueryDTO.getAddedFansNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCommentNumber()),"comment_number",oLiveShopApplyAddressQueryDTO.getCommentNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCommentUserNumber()),"comment_user_number",oLiveShopApplyAddressQueryDTO.getCommentUserNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLikeNumber()),"like_number",oLiveShopApplyAddressQueryDTO.getLikeNumber());
        return oLiveShopApplyAddressMapper.selectCount(oLiveShopApplyAddressQueryWrapper);
    }
    /*** 
    * 自定义分页查询VIEW
    * @param currentPage 当前页
    * @param pageSize 分页大小
    * @param oLiveShopApplyAddressEntity
    * @return Page
    **/
    @Override
    public Page selectLiveShopApplyAddressPage(int currentPage,int pageSize,LiveShopApplyAddressQueryDTO oLiveShopApplyAddressQueryDTO)
    {
        if(currentPage <= 1)
        {
            currentPage = 1;
        }
        if(pageSize <= 0)
        {
            pageSize = 10;
        }
        Page<LiveShopApplyAddressEntity> pageParams = new Page<>(currentPage,pageSize);
        QueryWrapper<LiveShopApplyAddressEntity> oLiveShopApplyAddressQueryWrapper = new QueryWrapper();
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getId()),"id",oLiveShopApplyAddressQueryDTO.getId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopName()),"shop_name",oLiveShopApplyAddressQueryDTO.getShopName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getMerchantName()),"merchant_name",oLiveShopApplyAddressQueryDTO.getMerchantName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveHomeName()),"live_home_name",oLiveShopApplyAddressQueryDTO.getLiveHomeName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveHomePicture()),"live_home_picture",oLiveShopApplyAddressQueryDTO.getLiveHomePicture());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveId()),"live_id",oLiveShopApplyAddressQueryDTO.getLiveId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveShopId()),"live_shop_id",oLiveShopApplyAddressQueryDTO.getLiveShopId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopId()),"shop_id",oLiveShopApplyAddressQueryDTO.getShopId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getApplyId()),"apply_id",oLiveShopApplyAddressQueryDTO.getApplyId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopUserId()),"shop_user_id",oLiveShopApplyAddressQueryDTO.getShopUserId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getShopUserName()),"shop_user_name",oLiveShopApplyAddressQueryDTO.getShopUserName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCreateUserId()),"create_user_id",oLiveShopApplyAddressQueryDTO.getCreateUserId());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveAuthType()),"live_auth_type",oLiveShopApplyAddressQueryDTO.getLiveAuthType());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveStartTime()),"live_start_time",oLiveShopApplyAddressQueryDTO.getLiveStartTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveEndTime()),"live_end_time",oLiveShopApplyAddressQueryDTO.getLiveEndTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveAppName()),"live_app_name",oLiveShopApplyAddressQueryDTO.getLiveAppName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveStreamName()),"live_stream_name",oLiveShopApplyAddressQueryDTO.getLiveStreamName());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushAuth()),"push_auth",oLiveShopApplyAddressQueryDTO.getPushAuth());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushUrl()),"push_url",oLiveShopApplyAddressQueryDTO.getPushUrl());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveUrl()),"live_url",oLiveShopApplyAddressQueryDTO.getLiveUrl());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLivePicture()),"live_picture",oLiveShopApplyAddressQueryDTO.getLivePicture());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveDescription()),"live_description",oLiveShopApplyAddressQueryDTO.getLiveDescription());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveTag()),"live_tag",oLiveShopApplyAddressQueryDTO.getLiveTag());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveState()),"live_state",oLiveShopApplyAddressQueryDTO.getLiveState());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveWillSave()),"live_will_save",oLiveShopApplyAddressQueryDTO.getLiveWillSave());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveFeesType()),"live_fees_type",oLiveShopApplyAddressQueryDTO.getLiveFeesType());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveUserPush()),"live_user_push",oLiveShopApplyAddressQueryDTO.getLiveUserPush());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushStartTime()),"push_start_time",oLiveShopApplyAddressQueryDTO.getPushStartTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushEndTime()),"push_end_time",oLiveShopApplyAddressQueryDTO.getPushEndTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushStartServerTime()),"push_start_server_time",oLiveShopApplyAddressQueryDTO.getPushStartServerTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getPushEndServerTime()),"push_end_server_time",oLiveShopApplyAddressQueryDTO.getPushEndServerTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveTotallDuration()),"live_totall_duration",oLiveShopApplyAddressQueryDTO.getLiveTotallDuration());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveTotallPushLength()),"live_totall_push_length",oLiveShopApplyAddressQueryDTO.getLiveTotallPushLength());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveFees()),"live_fees",oLiveShopApplyAddressQueryDTO.getLiveFees());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveValuation()),"live_valuation",oLiveShopApplyAddressQueryDTO.getLiveValuation());
        oLiveShopApplyAddressQueryWrapper.ge(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCreateTimeStart()),"create_time",oLiveShopApplyAddressQueryDTO.getCreateTimeStart());
        oLiveShopApplyAddressQueryWrapper.le(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCreateTimeEnd()),"create_time",oLiveShopApplyAddressQueryDTO.getCreateTimeEnd());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getUpdateTime()),"update_time",oLiveShopApplyAddressQueryDTO.getUpdateTime());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchNumber()),"watch_number",oLiveShopApplyAddressQueryDTO.getWatchNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchUserCount()),"watch_user_count",oLiveShopApplyAddressQueryDTO.getWatchUserCount());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchDuration()),"watch_duration",oLiveShopApplyAddressQueryDTO.getWatchDuration());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchStreamLength()),"watch_stream_length",oLiveShopApplyAddressQueryDTO.getWatchStreamLength());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getMaxOnlineUserCount()),"max_online_user_count",oLiveShopApplyAddressQueryDTO.getMaxOnlineUserCount());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getAveragWatchDuration()),"averag_watch_duration",oLiveShopApplyAddressQueryDTO.getAveragWatchDuration());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveOrderCount()),"live_order_count",oLiveShopApplyAddressQueryDTO.getLiveOrderCount());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLiveOrderTotalFee()),"live_order_total_fee",oLiveShopApplyAddressQueryDTO.getLiveOrderTotalFee());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getWatchUserPayRate()),"watch_user_pay_rate",oLiveShopApplyAddressQueryDTO.getWatchUserPayRate());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getAddedFansNumber()),"added_fans_number",oLiveShopApplyAddressQueryDTO.getAddedFansNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCommentNumber()),"comment_number",oLiveShopApplyAddressQueryDTO.getCommentNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getCommentUserNumber()),"comment_user_number",oLiveShopApplyAddressQueryDTO.getCommentUserNumber());
        oLiveShopApplyAddressQueryWrapper.eq(ObjectUtil.isNotEmpty(oLiveShopApplyAddressQueryDTO.getLikeNumber()),"like_number",oLiveShopApplyAddressQueryDTO.getLikeNumber());
        return oLiveShopApplyAddressMapper.selectPage(pageParams, oLiveShopApplyAddressQueryWrapper);
    }
}
    

